{ "cells": [ { "cell_type": "markdown", "id": "57a92274", "metadata": {}, "source": [ "# Interconnection Queues" ] }, { "cell_type": "code", "execution_count": 1, "id": "3599dfce", "metadata": {}, "outputs": [], "source": [ "import gridstatus\n", "import pandas as pd\n", "import plotly.express as px\n" ] }, { "cell_type": "markdown", "id": "82965289", "metadata": {}, "source": [ "## NYISO Interconnection Queue\n", "\n", "The `get_interconnection_queue` call returns projects that are \"active\", \"completed\", and \"withdrawn\"" ] }, { "cell_type": "code", "execution_count": 2, "id": "5e62d100", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Queue IDProject NameInterconnecting EntityCountyStateInterconnection LocationTransmission OwnerGeneration TypeCapacity (MW)Summer Capacity (MW)...Withdrawn DateWithdrawal CommentActual Completion DateProposed In-ServiceProposed Initial-SyncLast UpdateZSAvailability of StudiesFS Complete/ SGIA Tender
00276Homer Solar Energy CenterHomer Solar Energy Center, LLCCortlandNYCortland - Fenner 115kVNM-NGSolar90.090.0...NaNNaNNaN2023-08-012023-09-012022-09-30 00:00:00C10.0FES, SRIS, FS2021-02-08 00:00:00
10386Grand Isle IntertieVermont Green Line Devco, LLCClintonNYPlattsburgh 230kV-New Haven, VT 345kVNYPADC Transmission400.0400.0...NaNNaNNaN2023-12-01NaT2018-11-30 00:00:00D6.0FES, SISNaT
20393Berrians East ReplacementNRG Berrians East Development, LLCQueensNYAstoria East 138kVConEdDual Fuel94.294.2...NaNNaNNaN2024-05-012024-08-012022-06-30 00:00:00J11.0FES, SRIS, FS2019-07-09 00:00:00
30396Baron WindsBaron Winds, LLCSteubenNYHillside - Meyer 230kVNYSEGWind238.4238.4...NaNNaNNaN2022-05-012022-06-012021-11-30 00:00:00C11.0FES, SRIS, FS2019-07-09 00:00:00
40396AWood Street TransformerNew York State Electric & GasPutnamNYWood St. 345/115kVNYSEGAC TransmissionNaNNaN...NaNNaNNaN2022-12-01NaT2021-04-30 00:00:00G12.0SISNaT
..................................................................
116583FultonErie Boulevard Hydropower, LPOswegoNYFay St. 34.5kVNM-NGHydro1.31.3...NaNNaN3/31/182025-07-012025-11-013/31/18C14FS2017-07-12 00:00:00
1170696Swinging Bridge Unit 3Eagle Creek Hydro Power, LLCOrangeNYSwing Bridge 69 kVO&RHydro1.21.2...NaNNaN2020-04-30 00:00:002024-11-012024-12-012020-04-30 00:00:00G14NaN2018-06-20 00:00:00
1180701KCE NY 1KCE NY 1, LLCSaratogaNYLuther - Forest Substation 34.5kVNYSEGEnergy Storage20.020.0...NaNNaN2020-04-30 00:00:002022-10-012022-11-012020-04-30 00:00:00F14NaN2018-06-20 00:00:00
1190731Branscomb SolarBranscomb Solar, LLCWashingtonNYBattenkill - Eastover 115kVNM-NGSolar20.020.0...NaNNaN2022-03-31 00:00:002024-11-012025-02-012022-03-31 00:00:00F14FES, SIS, FS2020-04-29 00:00:00
1200781Marcy South SSR DetectionNew York Power AuthorityDelawareNYFraser - Annex 345 kV SubstationNYPAAC TransmissionNaNNaN...NaNNaN2020-04-30 00:00:002023-09-012023-09-012020-04-30 00:00:00E14SISNaN
\n", "

1418 rows × 24 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name Interconnecting Entity \\\n", "0 0276 Homer Solar Energy Center Homer Solar Energy Center, LLC \n", "1 0386 Grand Isle Intertie Vermont Green Line Devco, LLC \n", "2 0393 Berrians East Replacement NRG Berrians East Development, LLC \n", "3 0396 Baron Winds Baron Winds, LLC \n", "4 0396A Wood Street Transformer New York State Electric & Gas \n", ".. ... ... ... \n", "116 583 Fulton Erie Boulevard Hydropower, LP \n", "117 0696 Swinging Bridge Unit 3 Eagle Creek Hydro Power, LLC \n", "118 0701 KCE NY 1 KCE NY 1, LLC \n", "119 0731 Branscomb Solar Branscomb Solar, LLC \n", "120 0781 Marcy South SSR Detection New York Power Authority \n", "\n", " County State Interconnection Location \\\n", "0 Cortland NY Cortland - Fenner 115kV \n", "1 Clinton NY Plattsburgh 230kV-New Haven, VT 345kV \n", "2 Queens NY Astoria East 138kV \n", "3 Steuben NY Hillside - Meyer 230kV \n", "4 Putnam NY Wood St. 345/115kV \n", ".. ... ... ... \n", "116 Oswego NY Fay St. 34.5kV \n", "117 Orange NY Swing Bridge 69 kV \n", "118 Saratoga NY Luther - Forest Substation 34.5kV \n", "119 Washington NY Battenkill - Eastover 115kV \n", "120 Delaware NY Fraser - Annex 345 kV Substation \n", "\n", " Transmission Owner Generation Type Capacity (MW) Summer Capacity (MW) \\\n", "0 NM-NG Solar 90.0 90.0 \n", "1 NYPA DC Transmission 400.0 400.0 \n", "2 ConEd Dual Fuel 94.2 94.2 \n", "3 NYSEG Wind 238.4 238.4 \n", "4 NYSEG AC Transmission NaN NaN \n", ".. ... ... ... ... \n", "116 NM-NG Hydro 1.3 1.3 \n", "117 O&R Hydro 1.2 1.2 \n", "118 NYSEG Energy Storage 20.0 20.0 \n", "119 NM-NG Solar 20.0 20.0 \n", "120 NYPA AC Transmission NaN NaN \n", "\n", " ... Withdrawn Date Withdrawal Comment Actual Completion Date \\\n", "0 ... NaN NaN NaN \n", "1 ... NaN NaN NaN \n", "2 ... NaN NaN NaN \n", "3 ... NaN NaN NaN \n", "4 ... NaN NaN NaN \n", ".. ... ... ... ... \n", "116 ... NaN NaN 3/31/18 \n", "117 ... NaN NaN 2020-04-30 00:00:00 \n", "118 ... NaN NaN 2020-04-30 00:00:00 \n", "119 ... NaN NaN 2022-03-31 00:00:00 \n", "120 ... NaN NaN 2020-04-30 00:00:00 \n", "\n", " Proposed In-Service Proposed Initial-Sync Last Update Z S \\\n", "0 2023-08-01 2023-09-01 2022-09-30 00:00:00 C 10.0 \n", "1 2023-12-01 NaT 2018-11-30 00:00:00 D 6.0 \n", "2 2024-05-01 2024-08-01 2022-06-30 00:00:00 J 11.0 \n", "3 2022-05-01 2022-06-01 2021-11-30 00:00:00 C 11.0 \n", "4 2022-12-01 NaT 2021-04-30 00:00:00 G 12.0 \n", ".. ... ... ... .. ... \n", "116 2025-07-01 2025-11-01 3/31/18 C 14 \n", "117 2024-11-01 2024-12-01 2020-04-30 00:00:00 G 14 \n", "118 2022-10-01 2022-11-01 2020-04-30 00:00:00 F 14 \n", "119 2024-11-01 2025-02-01 2022-03-31 00:00:00 F 14 \n", "120 2023-09-01 2023-09-01 2020-04-30 00:00:00 E 14 \n", "\n", " Availability of Studies FS Complete/ SGIA Tender \n", "0 FES, SRIS, FS 2021-02-08 00:00:00 \n", "1 FES, SIS NaT \n", "2 FES, SRIS, FS 2019-07-09 00:00:00 \n", "3 FES, SRIS, FS 2019-07-09 00:00:00 \n", "4 SIS NaT \n", ".. ... ... \n", "116 FS 2017-07-12 00:00:00 \n", "117 NaN 2018-06-20 00:00:00 \n", "118 NaN 2018-06-20 00:00:00 \n", "119 FES, SIS, FS 2020-04-29 00:00:00 \n", "120 SIS NaN \n", "\n", "[1418 rows x 24 columns]" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "iso = gridstatus.NYISO()\n", "queue = iso.get_interconnection_queue()\n", "queue.head()" ] }, { "cell_type": "code", "execution_count": 3, "id": "4b9a440a", "metadata": {}, "outputs": [ { "data": { "image/svg+xml": "WithdrawnActiveCompleted0100200300400500600700800Project by Status - NYISOindexStatus" }, "metadata": {}, "output_type": "display_data" } ], "source": [ "status_distributions = queue[\"Status\"].value_counts()\n", "fig = px.bar(status_distributions, x=status_distributions.index, y=\"Status\", title=\"Project by Status - NYISO\")\n", "fig.show(\"svg\")" ] }, { "cell_type": "markdown", "id": "831647bc", "metadata": {}, "source": [ "## Days in Queue" ] }, { "cell_type": "code", "execution_count": 4, "id": "dd3179bf", "metadata": { "tags": [] }, "outputs": [ { "data": { "image/svg+xml": "01000200030004000500001020304050607080Days in Queue - Active Projects - NYISODays in Queuecount" }, "metadata": {}, "output_type": "display_data" } ], "source": [ "queue[\"Days in Queue\"] = (pd.Timestamp.now() - queue[\"Queue Date\"]).dt.days\n", "active = queue[queue[\"Status\"] == \"Active\"]\n", "fig = px.histogram(active, x=\"Days in Queue\", title=\"Days in Queue - Active Projects - NYISO\")\n", "fig.show(\"svg\")\n" ] }, { "cell_type": "markdown", "id": "09af99f7", "metadata": {}, "source": [ "## Top Active Project Types" ] }, { "cell_type": "code", "execution_count": 5, "id": "53eceb78", "metadata": {}, "outputs": [ { "data": { "application/vnd.plotly.v1+json": { "config": { "plotlyServerURL": "https://plot.ly" }, "data": [ { "alignmentgroup": "True", "hovertemplate": "index=%{x}
Generation Type=%{y}", "legendgroup": "", "marker": { "color": "#636efa", "pattern": { "shape": "" } }, "name": "", "offsetgroup": "", "orientation": "v", "showlegend": false, "textposition": "auto", "type": "bar", "x": [ "Solar", "Energy Storage", "Wind", "AC Transmission", "DC Transmission", "Load", "Combined Cycle", "Dual Fuel", "Combustion Turbine" ], "xaxis": "x", "y": [ 188, 149, 79, 31, 14, 7, 3, 1, 1 ], "yaxis": "y" } ], "layout": { "barmode": "relative", "legend": { "tracegroupgap": 0 }, "template": { "data": { "bar": [ { "error_x": { "color": "#2a3f5f" }, "error_y": { "color": "#2a3f5f" }, "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "bar" } ], "barpolar": [ { "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "barpolar" } ], "carpet": [ { "aaxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "baxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "type": "carpet" } ], "choropleth": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "choropleth" } ], "contour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "contour" } ], "contourcarpet": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "contourcarpet" } ], "heatmap": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "heatmap" } ], "heatmapgl": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "heatmapgl" } ], "histogram": [ { "marker": { "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "histogram" } ], "histogram2d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "histogram2d" } ], "histogram2dcontour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "histogram2dcontour" } ], "mesh3d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "mesh3d" } ], "parcoords": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "parcoords" } ], "pie": [ { "automargin": true, "type": "pie" } ], "scatter": [ { "fillpattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 }, "type": "scatter" } ], "scatter3d": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter3d" } ], "scattercarpet": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattercarpet" } ], "scattergeo": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergeo" } ], "scattergl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergl" } ], "scattermapbox": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattermapbox" } ], "scatterpolar": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolar" } ], "scatterpolargl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolargl" } ], "scatterternary": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterternary" } ], "surface": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "surface" } ], "table": [ { "cells": { "fill": { "color": "#EBF0F8" }, "line": { "color": "white" } }, "header": { "fill": { "color": "#C8D4E3" }, "line": { "color": "white" } }, "type": "table" } ] }, "layout": { "annotationdefaults": { "arrowcolor": "#2a3f5f", "arrowhead": 0, "arrowwidth": 1 }, "autotypenumbers": "strict", "coloraxis": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "colorscale": { "diverging": [ [ 0, "#8e0152" ], [ 0.1, "#c51b7d" ], [ 0.2, "#de77ae" ], [ 0.3, "#f1b6da" ], [ 0.4, "#fde0ef" ], [ 0.5, "#f7f7f7" ], [ 0.6, "#e6f5d0" ], [ 0.7, "#b8e186" ], [ 0.8, "#7fbc41" ], [ 0.9, "#4d9221" ], [ 1, "#276419" ] ], "sequential": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "sequentialminus": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ] }, "colorway": [ "#636efa", "#EF553B", "#00cc96", "#ab63fa", "#FFA15A", "#19d3f3", "#FF6692", "#B6E880", "#FF97FF", "#FECB52" ], "font": { "color": "#2a3f5f" }, "geo": { "bgcolor": "white", "lakecolor": "white", "landcolor": "#E5ECF6", "showlakes": true, "showland": true, "subunitcolor": "white" }, "hoverlabel": { "align": "left" }, "hovermode": "closest", "mapbox": { "style": "light" }, "paper_bgcolor": "white", "plot_bgcolor": "#E5ECF6", "polar": { "angularaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "radialaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "scene": { "xaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "yaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "zaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" } }, "shapedefaults": { "line": { "color": "#2a3f5f" } }, "ternary": { "aaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "baxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "caxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "title": { "x": 0.05 }, "xaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 }, "yaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 } } }, "title": { "text": "Project by Type - NYISO" }, "xaxis": { "anchor": "y", "domain": [ 0, 1 ], "title": { "text": "index" } }, "yaxis": { "anchor": "x", "domain": [ 0, 1 ], "title": { "text": "Generation Type" } } } } }, "metadata": {}, "output_type": "display_data" } ], "source": [ "generation_types = active[\"Generation Type\"].value_counts()\n", "fig = px.bar(generation_types, x=generation_types.index, y=\"Generation Type\", title=\"Project by Type - NYISO\")\n", "fig.show(\"svg\")" ] }, { "cell_type": "markdown", "id": "a5d6e271", "metadata": {}, "source": [ "## Proposed Completion Date" ] }, { "cell_type": "code", "execution_count": 20, "id": "5810554d", "metadata": {}, "outputs": [ { "data": { "image/svg+xml": "20222024202620282030020406080100Generation TypeSolarDC TransmissionDual FuelWindAC TransmissionEnergy StorageLoadCombined CycleCombustion TurbineProposed Completion Date - NYISOProposed Completion Datecount" }, "metadata": {}, "output_type": "display_data" } ], "source": [ "fig = px.histogram(active, x=\"Proposed Completion Date\", title=\"Proposed Completion Date - NYISO\", color=\"Generation Type\")\n", "fig.show('svg')" ] }, { "cell_type": "markdown", "id": "e6e24a54", "metadata": {}, "source": [ "## Get Interconnection Queue Data from All ISOs" ] }, { "cell_type": "code", "execution_count": 24, "id": "6b124082", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "100%|██████████| 7/7 [00:21<00:00, 3.01s/it]\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ISOQueue IDProject NameInterconnecting EntityCountyStateInterconnection LocationTransmission OwnerGeneration TypeCapacity (MW)Summer Capacity (MW)Winter Capacity (MW)Queue DateStatusProposed Completion DateWithdrawn DateWithdrawal CommentActual Completion Date
0Midcontinent ISOE002NoneNonePointe CoupeeLA500 kV switchyard at Big Cajon IIEntergyGas15.00000015.015.02013-09-13T04:00:00ZDoneNoneNoneNoneNone
1Midcontinent ISOE291NoneNoneTXRich 138 kV substationEntergyHydro27.00000027.027.02012-05-15T04:00:00ZDone2016-01-31T05:00:00ZNoneNoneNone
2Midcontinent ISOG001NoneNoneBrown CountyWIUnknownAmerican Transmission Co. LLC255.000000255.0255.01995-11-08T05:00:00ZWithdrawn2014-11-17T05:00:00ZNoneNoneNone
3Midcontinent ISOG002NoneNoneTrimble CountyKYUnknownLG&E and KU Services Company as agent for Loui...Coal174.000000174.0174.01998-12-01T05:00:00ZDone2016-01-01T05:00:00ZNoneNoneNone
4Midcontinent ISOG003NoneNoneTrimble CountyKYUnknownLG&E and KU Services Company as agent for Loui...Coal174.000000174.0174.01998-12-01T05:00:00ZDone2004-01-01T05:00:00ZNoneNoneNone
.........................................................
19557ISO New England1308Uxbridge Substation – NG Hopedale West Group S...NoneWorcesterMANG Feeder 321W6, Uxbridge T2NaNBAT6.9940006.9946.9942022-09-09 00:00:00Withdrawn2024-11-15 00:00:00NaTNoneNone
19558ISO New England1310Battery StorageNoneBerkshireMA115 kV Transmission line (1211 - Present betwe...NaNBAT118.750000118.75118.752022-09-22 00:00:00Withdrawn2025-09-30 00:00:00NaTNoneNone
19559ISO New England1314Offshore WindNoneNaNMAEversource 115kV Acushnet, lines 112/114NaNWND470.000000470.0470.02022-09-26 00:00:00Withdrawn2029-09-01 00:00:00NaTNoneNone
19560ISO New England1315Battery StorageNoneWindhamCTEversource Killingly Substation,115kV BUS, Tra...NaNBAT106.970001106.970001106.9700012022-09-28 00:00:00Withdrawn2026-06-09 00:00:00NaTNoneNone
19561ISO New England1316Solar plus BatteryNoneCheshireNHEversource 115kV line L163NaNSUN BAT102.000000102.0102.02022-09-30 00:00:00Withdrawn2027-10-28 00:00:00NaTNoneNone
\n", "

19562 rows × 18 columns

\n", "
" ], "text/plain": [ " ISO Queue ID \\\n", "0 Midcontinent ISO E002 \n", "1 Midcontinent ISO E291 \n", "2 Midcontinent ISO G001 \n", "3 Midcontinent ISO G002 \n", "4 Midcontinent ISO G003 \n", "... ... ... \n", "19557 ISO New England 1308 \n", "19558 ISO New England 1310 \n", "19559 ISO New England 1314 \n", "19560 ISO New England 1315 \n", "19561 ISO New England 1316 \n", "\n", " Project Name \\\n", "0 None \n", "1 None \n", "2 None \n", "3 None \n", "4 None \n", "... ... \n", "19557 Uxbridge Substation – NG Hopedale West Group S... \n", "19558 Battery Storage \n", "19559 Offshore Wind \n", "19560 Battery Storage \n", "19561 Solar plus Battery \n", "\n", " Interconnecting Entity County State \\\n", "0 None Pointe Coupee LA \n", "1 None TX \n", "2 None Brown County WI \n", "3 None Trimble County KY \n", "4 None Trimble County KY \n", "... ... ... ... \n", "19557 None Worcester MA \n", "19558 None Berkshire MA \n", "19559 None NaN MA \n", "19560 None Windham CT \n", "19561 None Cheshire NH \n", "\n", " Interconnection Location \\\n", "0 500 kV switchyard at Big Cajon II \n", "1 Rich 138 kV substation \n", "2 Unknown \n", "3 Unknown \n", "4 Unknown \n", "... ... \n", "19557 NG Feeder 321W6, Uxbridge T2 \n", "19558 115 kV Transmission line (1211 - Present betwe... \n", "19559 Eversource 115kV Acushnet, lines 112/114 \n", "19560 Eversource Killingly Substation,115kV BUS, Tra... \n", "19561 Eversource 115kV line L163 \n", "\n", " Transmission Owner Generation Type \\\n", "0 Entergy Gas \n", "1 Entergy Hydro \n", "2 American Transmission Co. LLC \n", "3 LG&E and KU Services Company as agent for Loui... Coal \n", "4 LG&E and KU Services Company as agent for Loui... Coal \n", "... ... ... \n", "19557 NaN BAT \n", "19558 NaN BAT \n", "19559 NaN WND \n", "19560 NaN BAT \n", "19561 NaN SUN BAT \n", "\n", " Capacity (MW) Summer Capacity (MW) Winter Capacity (MW) \\\n", "0 15.000000 15.0 15.0 \n", "1 27.000000 27.0 27.0 \n", "2 255.000000 255.0 255.0 \n", "3 174.000000 174.0 174.0 \n", "4 174.000000 174.0 174.0 \n", "... ... ... ... \n", "19557 6.994000 6.994 6.994 \n", "19558 118.750000 118.75 118.75 \n", "19559 470.000000 470.0 470.0 \n", "19560 106.970001 106.970001 106.970001 \n", "19561 102.000000 102.0 102.0 \n", "\n", " Queue Date Status Proposed Completion Date \\\n", "0 2013-09-13T04:00:00Z Done None \n", "1 2012-05-15T04:00:00Z Done 2016-01-31T05:00:00Z \n", "2 1995-11-08T05:00:00Z Withdrawn 2014-11-17T05:00:00Z \n", "3 1998-12-01T05:00:00Z Done 2016-01-01T05:00:00Z \n", "4 1998-12-01T05:00:00Z Done 2004-01-01T05:00:00Z \n", "... ... ... ... \n", "19557 2022-09-09 00:00:00 Withdrawn 2024-11-15 00:00:00 \n", "19558 2022-09-22 00:00:00 Withdrawn 2025-09-30 00:00:00 \n", "19559 2022-09-26 00:00:00 Withdrawn 2029-09-01 00:00:00 \n", "19560 2022-09-28 00:00:00 Withdrawn 2026-06-09 00:00:00 \n", "19561 2022-09-30 00:00:00 Withdrawn 2027-10-28 00:00:00 \n", "\n", " Withdrawn Date Withdrawal Comment Actual Completion Date \n", "0 None None None \n", "1 None None None \n", "2 None None None \n", "3 None None None \n", "4 None None None \n", "... ... ... ... \n", "19557 NaT None None \n", "19558 NaT None None \n", "19559 NaT None None \n", "19560 NaT None None \n", "19561 NaT None None \n", "\n", "[19562 rows x 18 columns]" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "all_queues = gridstatus.get_interconnection_queues()\n", "all_queues" ] }, { "cell_type": "code", "execution_count": 25, "id": "5c40fb33", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Withdrawn 7405\n", "Active 6431\n", "WITHDRAWN 1481\n", "In Service 1028\n", "Completed 751\n", "Done 746\n", "ACTIVE 594\n", "Engineering and Procurement 301\n", "Confirmed 223\n", "COMPLETED 199\n", "Retracted 131\n", "Suspended 74\n", "Under Construction 58\n", "Deactivated 54\n", "Partially in Service - Under Construction 46\n", "Annulled 24\n", "Withdrawn - Pending Cure 2\n", " 1\n", "Name: Status, dtype: int64" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "all_queues[\"Status\"].value_counts()" ] }, { "cell_type": "markdown", "id": "55660a55", "metadata": {}, "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3.10.2 64-bit ('gridstatus')", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.10.2" }, "vscode": { "interpreter": { "hash": "49f14642123d0cc1afa9fa45716ed5f1e915189c28b01efe02a8b7ec3c0a3fce" } } }, "nbformat": 4, "nbformat_minor": 5 }